<?xml version="1.0" encoding="utf-8"?>
<DatabaseSchema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <DatabaseName>SanelibDemo</DatabaseName>
  <Description>Generated from code</Description>
  <Tables>
    <TableName>SessionLog</TableName>
    <Description>Session Log for security purpose</Description>
    <IsAudited>false</IsAudited>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>SessionId</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>IpAddress</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>UserAgent</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>UserName</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>CheckIn</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>CheckOut</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Member</TableName>
    <Description>Site Users</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>TagId</PropertyName>
      <PropertySize>64</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Code</PropertyName>
      <PropertySize>64</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>DateOfBirth</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>Address</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Email</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Mobile</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>ScreenMessage</PropertyName>
      <PropertySize>512</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>ValidFrom</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>ValidTo</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Boolean</DataType>
      <PropertyName>SendSms</PropertyName>
      <PropertySize>1</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Boolean</DataType>
      <PropertyName>SendEmail</PropertyName>
      <PropertySize>1</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Boolean</DataType>
      <PropertyName>UsePrint</PropertyName>
      <PropertySize>1</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Boolean</DataType>
      <PropertyName>Block</PropertyName>
      <PropertySize>1</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>PasswordHash</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>PasswordSalt</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Integer</DataType>
      <PropertyName>FailedAttemptCount</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>Role</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>UserStatus</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>PasswordRetrievalToken</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>LastLoginTime</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>PasswordRetrievalTokenExpirationDate</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>LastPasswordChangedDate</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Session</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Templete</TableName>
    <Description>String Templete</Description>
    <IsAudited>false</IsAudited>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>Value</PropertyName>
      <PropertySize>4096</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Note</TableName>
    <Description>Notes for entities</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>EntityType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>ReferenceId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Account</TableName>
    <Description>General entity</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>AccountType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>AccountNumber</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>IndustryType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>BillingStreet</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>BillingCity</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>BillingState</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>BillingPostalCode</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>BillingCountry</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Currency</DataType>
      <PropertyName>BillingLatitude</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Currency</DataType>
      <PropertyName>BillingLongitude</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>ShippingStreet</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>ShippingCity</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>ShippingState</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>ShippingPostalCode</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>ShippingCountry</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Currency</DataType>
      <PropertyName>ShippingLatitude</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Currency</DataType>
      <PropertyName>ShippingLongitude</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Phone</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Mobile</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Fax</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Website</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Email</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Health</TableName>
    <Description>Application Health</Description>
    <IsAudited>false</IsAudited>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>HealthType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>Value</PropertyName>
      <PropertySize>2048</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>RecordTime</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Folder</TableName>
    <Description>Folders for Entity</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>Tags</PropertyName>
      <PropertySize>1024</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>EntityType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>ReferenceId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>ReferencedName</PropertyName>
      <PropertySize>256</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Contact</TableName>
    <Description>Generic Contact</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>LastName</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>FirstName</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>NameTitle</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Email</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Phone</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Mobile</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>CompanyName</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>Designation</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Leads</TableName>
    <Description>Contact Us form data</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>CompanyName</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Email</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Phone</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>AssignedContact</TableName>
    <Description>Assigned contacts for entity.</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>ContactId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>EntityType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>ReferenceId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Lead</TableName>
    <Description>Contact Us form data</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>CompanyName</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Email</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Phone</PropertyName>
      <PropertySize>16</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>TrackLog</TableName>
    <Description>Track Log</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>Code</PropertyName>
      <PropertySize>64</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>DetectedOn</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>TaskLog</TableName>
    <Description>NSBus Logs</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>StartTime</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>EndTime</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>TaskStatus</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>AttachmentId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>AssignedFolder</TableName>
    <Description>Assigned folders for account.</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>FolderId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>EntityType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>ReferenceId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>Attachment</TableName>
    <Description>Attachment for all entities</Description>
    <IsAudited>true</IsAudited>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>FileType</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>LongInteger</DataType>
      <PropertyName>FileSize</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>FileHashCode</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Image</DataType>
      <PropertyName>FileData</PropertyName>
      <PropertySize>0</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Enumeration</DataType>
      <PropertyName>EntityType</PropertyName>
      <PropertySize>2</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>Guid</DataType>
      <PropertyName>ReferenceId</PropertyName>
      <PropertySize>32</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>false</IsNull>
    </Columns>
    <Columns>
      <DataType>UnicodeString</DataType>
      <PropertyName>Tags</PropertyName>
      <PropertySize>1024</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
  <Tables>
    <TableName>NewsLetter</TableName>
    <Description />
    <IsAudited>false</IsAudited>
    <Columns>
      <DataType>AnsiString</DataType>
      <PropertyName>Email</PropertyName>
      <PropertySize>128</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>Boolean</DataType>
      <PropertyName>IsActive</PropertyName>
      <PropertySize>1</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
    <Columns>
      <DataType>DateTime</DataType>
      <PropertyName>InsertedDate</PropertyName>
      <PropertySize>8</PropertySize>
      <IsUnique>false</IsUnique>
      <IsIndexed>false</IsIndexed>
      <IsNull>true</IsNull>
    </Columns>
  </Tables>
</DatabaseSchema>